Tabela DictionaryValue

Definicja tabeli DictionaryValue

Name

DictionaryValue

Code

DictionaryValue

Comment

 


Lista kolumn tabeli DictionaryValue

Name

Code

DictionaryValueID

DictionaryValueID

DictionaryID

DictionaryID

Dic_DictionaryID

Dic_DictionaryID

Active

Active

SequenceNo

SequenceNo

StartDT

StartDT

StopDT

StopDT


Kolumna DictionaryValueID tabeli DictionaryValue

Definicja kolumny DictionaryValueID tabeli DictionaryValue

Name

DictionaryValueID

Code

DictionaryValueID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DictionaryID tabeli DictionaryValue

Definicja kolumny DictionaryID tabeli DictionaryValue

Name

DictionaryID

Code

DictionaryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Dic_DictionaryID tabeli DictionaryValue

Definicja kolumny Dic_DictionaryID tabeli DictionaryValue

Name

Dic_DictionaryID

Code

Dic_DictionaryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli DictionaryValue

Definicja kolumny Active tabeli DictionaryValue

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna SequenceNo tabeli DictionaryValue

Definicja kolumny SequenceNo tabeli DictionaryValue

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna StartDT tabeli DictionaryValue

Definicja kolumny StartDT tabeli DictionaryValue

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli DictionaryValue

Definicja kolumny StopDT tabeli DictionaryValue

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli DictionaryValue

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DictionaryValue

Definicja klucza Identifier_1 tabeli DictionaryValue

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment